﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;

namespace Transactions
{
    internal class QueryByJYMDTransction : QueryTransaction
    {
        public QueryByJYMDTransction(string projectName)
        {
            this._projectName = projectName;
        }

        public override void Query()
        {
            OleDbConnection connection = DatabaseManager.ConnectManager2.GetSystemConnect();
            string condition = "where 项目编号='" + _projectName + "'";
            OleDbCommandBuilder oledbCmdBuilder;
            oledbAdapter = new OleDbDataAdapter(_queryString + condition, connection);
            oledbCmdBuilder = new OleDbCommandBuilder(oledbAdapter);
            oledbAdapter.Fill(base.result);   	
        }

        private string _projectName;
        private static string _queryString = "select  * from ksd_CWrishouru";

        private OleDbDataAdapter oledbAdapter;
    }
}
